create external table jms_dim.dim_nwm_staff_settle_config_base
(
    id          bigint ,
    network_code      string comment '所属网点编号',
    network_name      string comment '所属网点名称',
    staff_code       string comment '业务员编号',
    staff_name       string comment '业务员名称',
    staff_type      int comment '业务员类型',
    settle_staff_code string comment '结算业务员编号',
    settle_staff_name string comment '结算业务员名称',
    weight_source     int comment '计费重量取值',
    is_settle_mode_x  int comment '是否散单出港结算 1-是 0-否',
    is_settle_mode_y  int comment '是否到付单出港结算 1-是 0-否',
    settlement_cycle  int comment '扣款周期',
    create_by         string comment '创建人',
    create_by_name    string comment '创建人名称',
    create_time      TIMESTAMP comment '创建时间',
    update_by        string COMMENT '更新人',
    update_by_name   string COMMENT '更新人名称',
    update_time      TIMESTAMP comment '更新时间',
    belong_type      int comment '所属类别'
)comment '业务员结算配置'
stored as parquet
LOCATION
'/dw/hive/jms_dim.db/external/dim_nwm_staff_settle_config_base';